You can make a difference in the Apple Support Community!
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
I imported a spreadsheet from a bank acct as CVS format to Numbers. All cells are formatted as text and I'm unable to to change the format of cells with real numbers from text to numbers.
Mac mini, macOS 10.15
Hi ingosan ,
You wrote, in reply to Yellowbox:
"Note:
the formula you gave for S2 should be R2+0 otherwise the result changes by 1 as you can see in the last column"
I think Yellowbox was using the formula you gave in your initial example:
Regards,
Barry
Hi ingosan ,
You wrote, in reply to Yellowbox:
"Note:
the formula you gave for S2 should be R2+0 otherwise the result changes by 1 as you can see in the last column"
I think Yellowbox was using the formula you gave in your initial example:
Regards,
Barry
Hi Ingosan,
The bank account is using comma as the decimal separator. That would be correct in (say) German. If your document uses English formatting, you need to substitute commas with dots.
Formula in R2 =SUBSTITUTE(O2,",",".")
Formula in S2 =R2+1
Regards,
Ian.
To transform a text value into a number, you can use the VALUE function.
For example, you can make a new column C and in C2 insert the function =VALUE(B2). You'll get a number in C2. For the rest, copy and paste…
Thank you for your Help.
The comma separator is the clue. I needed to replace the comma with the dot.
The way I did it :
select the column with the number value formulated as Text
go to Edit select Find, Find
enter in Find " , "and in Replace with " . " (without the "). click on Replace all.
all commas changed to dot seperator
Close the Find window.
select the column again and go to Format in the Menu bar
select Cell
under Data Format select Number or Currency. Enter
and from hereon you can add, subtract and all other functions with Numbers
Note:
the formula you gave for S2 should be R2+0 otherwise the result changes by 1 as you can see in the last column
Hi ingosan,
You should be able to do that here:
Select the column and make your change.
If not, there is something that is telling Numbers that this is definately a text string.
quinn
how to change a text formatted cell to a number format
