I am trying to put decimal places in a cell but the "general cell format" wonīt treat it as a number. I put "135.55" and it doesn't align to the right as numbers usually do. It is a new computer, the excel file works on my other computers.
Could somebody please help me correct this.
what does it do? Got a screenshot?
Here is a screenshot. It doesnīt treat it as a number so I canīt perform any operations over it. It is very weird.
screenshot.PNG
Can't see the png. Got a red x in the upper left corner.
screenshot.PNG
Now do you see it??
Nyet. Tried compatability view too. Maybe someone else can chime in.
Beats me. Might try right orientation format for the entire column. Stumped.
Try this as it's a new computer:
Control Panel Clock Language & Region
Change the date time or number format
Additional settings. Number format. Check for anomalies.
See if that helps.
Pete
Last edited by PeteABC123; 02-05-2015 at 05:44 PM. Reason: cuz
Screenshots show up just fine for me, but it is difficult to really investigate what is going on in a picture.
What do you get from the =ISTEXT() function?
What is your new system using for decimal separator (windows control panel -- regional settings)? I get the same behavior if I try to use a comma as a decimal separator ("125,66" will be treated as text because my system's decimal separator is period).
Originally Posted by shg
It was the regional settings! Thank you very much for the help!
Everything is now working as expected!
Appreciate it very much!
Removed by FR
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks