Excel Query

  billyliv 11:40 08 Jan 06
Locked

Hi, When I enter the number 3 into cell G12 then move down to G13 the number 3 changes to Jan-00 How do I keep the number 3 in G12? Cheers, Bill

  VoG II 11:44 08 Jan 06

Click in G12, Format|Cells and change the format to General or Number.

  Chris the Ancien 11:44 08 Jan 06

G12 has, somehow, been formatted as a date cell.

Go to the Format menu command, then cells. Select General and then all should be OK.

  Chris the Ancien 11:44 08 Jan 06

One day I'll beat you!

CtA

  billyliv 12:09 08 Jan 06

Thanks, First class service as usual. Cheers, bill

This thread is now locked and can not be replied to.

Huawei P10 review

1995-2015: How technology has changed the world in 20 years

How Nearly Normal created super-fun papercraft for Google

47 iPhone camera tips to help you take better photos