Cell Input ~ Display

G

Guest

Help! When inputting a number (i.e. 2) into a cell it displays as 0.02 ~ if
222 is entered it displays 2.22 this is whether the cell is formatted as
General, Number or Currency ~ Currency displays £0.02. Have checked Regional
& Language Options the Excel Options and all seems OK.

Regards
Ronnie
Email: (e-mail address removed)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Use Local Currency Symbol 1
Stop XL from changing format? 1
Incorrect Currency Displayed 4
error displaying large numbers 2
Formatting Cell that Contains If/Then Formula 5
Excel 2007 displayed dates 2
Negative Numbers in Parentheses 2
Excel not using regional settings 6

Top