Excel Query

  billyliv 11:40 08 Jan 2006
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 2006

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

  Chris the Ancien 11:44 08 Jan 2006

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 2006

One day I'll beat you!

CtA

  billyliv 12:09 08 Jan 2006

Thanks, First class service as usual. Cheers, bill

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

Elsewhere on IDG sites

AMD Ryzen news - release date, UK price, features and specifications

The pulp art of 80s computer game magazine covers

Best value Mac: Which is the best £1249 Mac to buy

Comment faire des captures d’écran sous Windows 10 ?